package com.shangdiao.sd_server.generator.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SdPersonExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SdPersonExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPersonIdIsNull() {
            addCriterion("PERSON_ID is null");
            return (Criteria) this;
        }

        public Criteria andPersonIdIsNotNull() {
            addCriterion("PERSON_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPersonIdEqualTo(Integer value) {
            addCriterion("PERSON_ID =", value, "personId");
            return (Criteria) this;
        }

        public Criteria andPersonIdNotEqualTo(Integer value) {
            addCriterion("PERSON_ID <>", value, "personId");
            return (Criteria) this;
        }

        public Criteria andPersonIdGreaterThan(Integer value) {
            addCriterion("PERSON_ID >", value, "personId");
            return (Criteria) this;
        }

        public Criteria andPersonIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("PERSON_ID >=", value, "personId");
            return (Criteria) this;
        }

        public Criteria andPersonIdLessThan(Integer value) {
            addCriterion("PERSON_ID <", value, "personId");
            return (Criteria) this;
        }

        public Criteria andPersonIdLessThanOrEqualTo(Integer value) {
            addCriterion("PERSON_ID <=", value, "personId");
            return (Criteria) this;
        }

        public Criteria andPersonIdIn(List<Integer> values) {
            addCriterion("PERSON_ID in", values, "personId");
            return (Criteria) this;
        }

        public Criteria andPersonIdNotIn(List<Integer> values) {
            addCriterion("PERSON_ID not in", values, "personId");
            return (Criteria) this;
        }

        public Criteria andPersonIdBetween(Integer value1, Integer value2) {
            addCriterion("PERSON_ID between", value1, value2, "personId");
            return (Criteria) this;
        }

        public Criteria andPersonIdNotBetween(Integer value1, Integer value2) {
            addCriterion("PERSON_ID not between", value1, value2, "personId");
            return (Criteria) this;
        }

        public Criteria andPersonNameIsNull() {
            addCriterion("PERSON_NAME is null");
            return (Criteria) this;
        }

        public Criteria andPersonNameIsNotNull() {
            addCriterion("PERSON_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andPersonNameEqualTo(String value) {
            addCriterion("PERSON_NAME =", value, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonNameNotEqualTo(String value) {
            addCriterion("PERSON_NAME <>", value, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonNameGreaterThan(String value) {
            addCriterion("PERSON_NAME >", value, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonNameGreaterThanOrEqualTo(String value) {
            addCriterion("PERSON_NAME >=", value, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonNameLessThan(String value) {
            addCriterion("PERSON_NAME <", value, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonNameLessThanOrEqualTo(String value) {
            addCriterion("PERSON_NAME <=", value, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonNameLike(String value) {
            addCriterion("PERSON_NAME like", value, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonNameNotLike(String value) {
            addCriterion("PERSON_NAME not like", value, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonNameIn(List<String> values) {
            addCriterion("PERSON_NAME in", values, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonNameNotIn(List<String> values) {
            addCriterion("PERSON_NAME not in", values, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonNameBetween(String value1, String value2) {
            addCriterion("PERSON_NAME between", value1, value2, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonNameNotBetween(String value1, String value2) {
            addCriterion("PERSON_NAME not between", value1, value2, "personName");
            return (Criteria) this;
        }

        public Criteria andPersonGenderIsNull() {
            addCriterion("PERSON_GENDER is null");
            return (Criteria) this;
        }

        public Criteria andPersonGenderIsNotNull() {
            addCriterion("PERSON_GENDER is not null");
            return (Criteria) this;
        }

        public Criteria andPersonGenderEqualTo(Integer value) {
            addCriterion("PERSON_GENDER =", value, "personGender");
            return (Criteria) this;
        }

        public Criteria andPersonGenderNotEqualTo(Integer value) {
            addCriterion("PERSON_GENDER <>", value, "personGender");
            return (Criteria) this;
        }

        public Criteria andPersonGenderGreaterThan(Integer value) {
            addCriterion("PERSON_GENDER >", value, "personGender");
            return (Criteria) this;
        }

        public Criteria andPersonGenderGreaterThanOrEqualTo(Integer value) {
            addCriterion("PERSON_GENDER >=", value, "personGender");
            return (Criteria) this;
        }

        public Criteria andPersonGenderLessThan(Integer value) {
            addCriterion("PERSON_GENDER <", value, "personGender");
            return (Criteria) this;
        }

        public Criteria andPersonGenderLessThanOrEqualTo(Integer value) {
            addCriterion("PERSON_GENDER <=", value, "personGender");
            return (Criteria) this;
        }

        public Criteria andPersonGenderIn(List<Integer> values) {
            addCriterion("PERSON_GENDER in", values, "personGender");
            return (Criteria) this;
        }

        public Criteria andPersonGenderNotIn(List<Integer> values) {
            addCriterion("PERSON_GENDER not in", values, "personGender");
            return (Criteria) this;
        }

        public Criteria andPersonGenderBetween(Integer value1, Integer value2) {
            addCriterion("PERSON_GENDER between", value1, value2, "personGender");
            return (Criteria) this;
        }

        public Criteria andPersonGenderNotBetween(Integer value1, Integer value2) {
            addCriterion("PERSON_GENDER not between", value1, value2, "personGender");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNull() {
            addCriterion("BIRTHDAY is null");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNotNull() {
            addCriterion("BIRTHDAY is not null");
            return (Criteria) this;
        }

        public Criteria andBirthdayEqualTo(Date value) {
            addCriterion("BIRTHDAY =", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotEqualTo(Date value) {
            addCriterion("BIRTHDAY <>", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThan(Date value) {
            addCriterion("BIRTHDAY >", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThanOrEqualTo(Date value) {
            addCriterion("BIRTHDAY >=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThan(Date value) {
            addCriterion("BIRTHDAY <", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThanOrEqualTo(Date value) {
            addCriterion("BIRTHDAY <=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayIn(List<Date> values) {
            addCriterion("BIRTHDAY in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotIn(List<Date> values) {
            addCriterion("BIRTHDAY not in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayBetween(Date value1, Date value2) {
            addCriterion("BIRTHDAY between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotBetween(Date value1, Date value2) {
            addCriterion("BIRTHDAY not between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andTelIsNull() {
            addCriterion("TEL is null");
            return (Criteria) this;
        }

        public Criteria andTelIsNotNull() {
            addCriterion("TEL is not null");
            return (Criteria) this;
        }

        public Criteria andTelEqualTo(String value) {
            addCriterion("TEL =", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotEqualTo(String value) {
            addCriterion("TEL <>", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelGreaterThan(String value) {
            addCriterion("TEL >", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelGreaterThanOrEqualTo(String value) {
            addCriterion("TEL >=", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLessThan(String value) {
            addCriterion("TEL <", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLessThanOrEqualTo(String value) {
            addCriterion("TEL <=", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLike(String value) {
            addCriterion("TEL like", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotLike(String value) {
            addCriterion("TEL not like", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelIn(List<String> values) {
            addCriterion("TEL in", values, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotIn(List<String> values) {
            addCriterion("TEL not in", values, "tel");
            return (Criteria) this;
        }

        public Criteria andTelBetween(String value1, String value2) {
            addCriterion("TEL between", value1, value2, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotBetween(String value1, String value2) {
            addCriterion("TEL not between", value1, value2, "tel");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("EMAIL is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("EMAIL is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("EMAIL =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("EMAIL <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("EMAIL >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("EMAIL >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("EMAIL <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("EMAIL <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("EMAIL like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("EMAIL not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("EMAIL in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("EMAIL not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("EMAIL between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("EMAIL not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andDistrictIdIsNull() {
            addCriterion("DISTRICT_ID is null");
            return (Criteria) this;
        }

        public Criteria andDistrictIdIsNotNull() {
            addCriterion("DISTRICT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDistrictIdEqualTo(Integer value) {
            addCriterion("DISTRICT_ID =", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdNotEqualTo(Integer value) {
            addCriterion("DISTRICT_ID <>", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdGreaterThan(Integer value) {
            addCriterion("DISTRICT_ID >", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DISTRICT_ID >=", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdLessThan(Integer value) {
            addCriterion("DISTRICT_ID <", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdLessThanOrEqualTo(Integer value) {
            addCriterion("DISTRICT_ID <=", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdIn(List<Integer> values) {
            addCriterion("DISTRICT_ID in", values, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdNotIn(List<Integer> values) {
            addCriterion("DISTRICT_ID not in", values, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdBetween(Integer value1, Integer value2) {
            addCriterion("DISTRICT_ID between", value1, value2, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DISTRICT_ID not between", value1, value2, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIsNull() {
            addCriterion("DISTRICT is null");
            return (Criteria) this;
        }

        public Criteria andDistrictIsNotNull() {
            addCriterion("DISTRICT is not null");
            return (Criteria) this;
        }

        public Criteria andDistrictEqualTo(String value) {
            addCriterion("DISTRICT =", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotEqualTo(String value) {
            addCriterion("DISTRICT <>", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictGreaterThan(String value) {
            addCriterion("DISTRICT >", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictGreaterThanOrEqualTo(String value) {
            addCriterion("DISTRICT >=", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictLessThan(String value) {
            addCriterion("DISTRICT <", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictLessThanOrEqualTo(String value) {
            addCriterion("DISTRICT <=", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictLike(String value) {
            addCriterion("DISTRICT like", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotLike(String value) {
            addCriterion("DISTRICT not like", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictIn(List<String> values) {
            addCriterion("DISTRICT in", values, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotIn(List<String> values) {
            addCriterion("DISTRICT not in", values, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictBetween(String value1, String value2) {
            addCriterion("DISTRICT between", value1, value2, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotBetween(String value1, String value2) {
            addCriterion("DISTRICT not between", value1, value2, "district");
            return (Criteria) this;
        }

        public Criteria andPostFlagIsNull() {
            addCriterion("POST_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andPostFlagIsNotNull() {
            addCriterion("POST_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andPostFlagEqualTo(Integer value) {
            addCriterion("POST_FLAG =", value, "postFlag");
            return (Criteria) this;
        }

        public Criteria andPostFlagNotEqualTo(Integer value) {
            addCriterion("POST_FLAG <>", value, "postFlag");
            return (Criteria) this;
        }

        public Criteria andPostFlagGreaterThan(Integer value) {
            addCriterion("POST_FLAG >", value, "postFlag");
            return (Criteria) this;
        }

        public Criteria andPostFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("POST_FLAG >=", value, "postFlag");
            return (Criteria) this;
        }

        public Criteria andPostFlagLessThan(Integer value) {
            addCriterion("POST_FLAG <", value, "postFlag");
            return (Criteria) this;
        }

        public Criteria andPostFlagLessThanOrEqualTo(Integer value) {
            addCriterion("POST_FLAG <=", value, "postFlag");
            return (Criteria) this;
        }

        public Criteria andPostFlagIn(List<Integer> values) {
            addCriterion("POST_FLAG in", values, "postFlag");
            return (Criteria) this;
        }

        public Criteria andPostFlagNotIn(List<Integer> values) {
            addCriterion("POST_FLAG not in", values, "postFlag");
            return (Criteria) this;
        }

        public Criteria andPostFlagBetween(Integer value1, Integer value2) {
            addCriterion("POST_FLAG between", value1, value2, "postFlag");
            return (Criteria) this;
        }

        public Criteria andPostFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("POST_FLAG not between", value1, value2, "postFlag");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdIsNull() {
            addCriterion("DIC_FIELD_ID is null");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdIsNotNull() {
            addCriterion("DIC_FIELD_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdEqualTo(Integer value) {
            addCriterion("DIC_FIELD_ID =", value, "dicFieldId");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdNotEqualTo(Integer value) {
            addCriterion("DIC_FIELD_ID <>", value, "dicFieldId");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdGreaterThan(Integer value) {
            addCriterion("DIC_FIELD_ID >", value, "dicFieldId");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DIC_FIELD_ID >=", value, "dicFieldId");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdLessThan(Integer value) {
            addCriterion("DIC_FIELD_ID <", value, "dicFieldId");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdLessThanOrEqualTo(Integer value) {
            addCriterion("DIC_FIELD_ID <=", value, "dicFieldId");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdIn(List<Integer> values) {
            addCriterion("DIC_FIELD_ID in", values, "dicFieldId");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdNotIn(List<Integer> values) {
            addCriterion("DIC_FIELD_ID not in", values, "dicFieldId");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdBetween(Integer value1, Integer value2) {
            addCriterion("DIC_FIELD_ID between", value1, value2, "dicFieldId");
            return (Criteria) this;
        }

        public Criteria andDicFieldIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DIC_FIELD_ID not between", value1, value2, "dicFieldId");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameIsNull() {
            addCriterion("DIC_FIELD_NAME is null");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameIsNotNull() {
            addCriterion("DIC_FIELD_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameEqualTo(String value) {
            addCriterion("DIC_FIELD_NAME =", value, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameNotEqualTo(String value) {
            addCriterion("DIC_FIELD_NAME <>", value, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameGreaterThan(String value) {
            addCriterion("DIC_FIELD_NAME >", value, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameGreaterThanOrEqualTo(String value) {
            addCriterion("DIC_FIELD_NAME >=", value, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameLessThan(String value) {
            addCriterion("DIC_FIELD_NAME <", value, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameLessThanOrEqualTo(String value) {
            addCriterion("DIC_FIELD_NAME <=", value, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameLike(String value) {
            addCriterion("DIC_FIELD_NAME like", value, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameNotLike(String value) {
            addCriterion("DIC_FIELD_NAME not like", value, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameIn(List<String> values) {
            addCriterion("DIC_FIELD_NAME in", values, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameNotIn(List<String> values) {
            addCriterion("DIC_FIELD_NAME not in", values, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameBetween(String value1, String value2) {
            addCriterion("DIC_FIELD_NAME between", value1, value2, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andDicFieldNameNotBetween(String value1, String value2) {
            addCriterion("DIC_FIELD_NAME not between", value1, value2, "dicFieldName");
            return (Criteria) this;
        }

        public Criteria andUniversityIdIsNull() {
            addCriterion("UNIVERSITY_ID is null");
            return (Criteria) this;
        }

        public Criteria andUniversityIdIsNotNull() {
            addCriterion("UNIVERSITY_ID is not null");
            return (Criteria) this;
        }

        public Criteria andUniversityIdEqualTo(Integer value) {
            addCriterion("UNIVERSITY_ID =", value, "universityId");
            return (Criteria) this;
        }

        public Criteria andUniversityIdNotEqualTo(Integer value) {
            addCriterion("UNIVERSITY_ID <>", value, "universityId");
            return (Criteria) this;
        }

        public Criteria andUniversityIdGreaterThan(Integer value) {
            addCriterion("UNIVERSITY_ID >", value, "universityId");
            return (Criteria) this;
        }

        public Criteria andUniversityIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("UNIVERSITY_ID >=", value, "universityId");
            return (Criteria) this;
        }

        public Criteria andUniversityIdLessThan(Integer value) {
            addCriterion("UNIVERSITY_ID <", value, "universityId");
            return (Criteria) this;
        }

        public Criteria andUniversityIdLessThanOrEqualTo(Integer value) {
            addCriterion("UNIVERSITY_ID <=", value, "universityId");
            return (Criteria) this;
        }

        public Criteria andUniversityIdIn(List<Integer> values) {
            addCriterion("UNIVERSITY_ID in", values, "universityId");
            return (Criteria) this;
        }

        public Criteria andUniversityIdNotIn(List<Integer> values) {
            addCriterion("UNIVERSITY_ID not in", values, "universityId");
            return (Criteria) this;
        }

        public Criteria andUniversityIdBetween(Integer value1, Integer value2) {
            addCriterion("UNIVERSITY_ID between", value1, value2, "universityId");
            return (Criteria) this;
        }

        public Criteria andUniversityIdNotBetween(Integer value1, Integer value2) {
            addCriterion("UNIVERSITY_ID not between", value1, value2, "universityId");
            return (Criteria) this;
        }

        public Criteria andUniversityIsNull() {
            addCriterion("UNIVERSITY is null");
            return (Criteria) this;
        }

        public Criteria andUniversityIsNotNull() {
            addCriterion("UNIVERSITY is not null");
            return (Criteria) this;
        }

        public Criteria andUniversityEqualTo(String value) {
            addCriterion("UNIVERSITY =", value, "university");
            return (Criteria) this;
        }

        public Criteria andUniversityNotEqualTo(String value) {
            addCriterion("UNIVERSITY <>", value, "university");
            return (Criteria) this;
        }

        public Criteria andUniversityGreaterThan(String value) {
            addCriterion("UNIVERSITY >", value, "university");
            return (Criteria) this;
        }

        public Criteria andUniversityGreaterThanOrEqualTo(String value) {
            addCriterion("UNIVERSITY >=", value, "university");
            return (Criteria) this;
        }

        public Criteria andUniversityLessThan(String value) {
            addCriterion("UNIVERSITY <", value, "university");
            return (Criteria) this;
        }

        public Criteria andUniversityLessThanOrEqualTo(String value) {
            addCriterion("UNIVERSITY <=", value, "university");
            return (Criteria) this;
        }

        public Criteria andUniversityLike(String value) {
            addCriterion("UNIVERSITY like", value, "university");
            return (Criteria) this;
        }

        public Criteria andUniversityNotLike(String value) {
            addCriterion("UNIVERSITY not like", value, "university");
            return (Criteria) this;
        }

        public Criteria andUniversityIn(List<String> values) {
            addCriterion("UNIVERSITY in", values, "university");
            return (Criteria) this;
        }

        public Criteria andUniversityNotIn(List<String> values) {
            addCriterion("UNIVERSITY not in", values, "university");
            return (Criteria) this;
        }

        public Criteria andUniversityBetween(String value1, String value2) {
            addCriterion("UNIVERSITY between", value1, value2, "university");
            return (Criteria) this;
        }

        public Criteria andUniversityNotBetween(String value1, String value2) {
            addCriterion("UNIVERSITY not between", value1, value2, "university");
            return (Criteria) this;
        }

        public Criteria andCollegeIdIsNull() {
            addCriterion("COLLEGE_ID is null");
            return (Criteria) this;
        }

        public Criteria andCollegeIdIsNotNull() {
            addCriterion("COLLEGE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCollegeIdEqualTo(Integer value) {
            addCriterion("COLLEGE_ID =", value, "collegeId");
            return (Criteria) this;
        }

        public Criteria andCollegeIdNotEqualTo(Integer value) {
            addCriterion("COLLEGE_ID <>", value, "collegeId");
            return (Criteria) this;
        }

        public Criteria andCollegeIdGreaterThan(Integer value) {
            addCriterion("COLLEGE_ID >", value, "collegeId");
            return (Criteria) this;
        }

        public Criteria andCollegeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("COLLEGE_ID >=", value, "collegeId");
            return (Criteria) this;
        }

        public Criteria andCollegeIdLessThan(Integer value) {
            addCriterion("COLLEGE_ID <", value, "collegeId");
            return (Criteria) this;
        }

        public Criteria andCollegeIdLessThanOrEqualTo(Integer value) {
            addCriterion("COLLEGE_ID <=", value, "collegeId");
            return (Criteria) this;
        }

        public Criteria andCollegeIdIn(List<Integer> values) {
            addCriterion("COLLEGE_ID in", values, "collegeId");
            return (Criteria) this;
        }

        public Criteria andCollegeIdNotIn(List<Integer> values) {
            addCriterion("COLLEGE_ID not in", values, "collegeId");
            return (Criteria) this;
        }

        public Criteria andCollegeIdBetween(Integer value1, Integer value2) {
            addCriterion("COLLEGE_ID between", value1, value2, "collegeId");
            return (Criteria) this;
        }

        public Criteria andCollegeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("COLLEGE_ID not between", value1, value2, "collegeId");
            return (Criteria) this;
        }

        public Criteria andCollegeIsNull() {
            addCriterion("COLLEGE is null");
            return (Criteria) this;
        }

        public Criteria andCollegeIsNotNull() {
            addCriterion("COLLEGE is not null");
            return (Criteria) this;
        }

        public Criteria andCollegeEqualTo(String value) {
            addCriterion("COLLEGE =", value, "college");
            return (Criteria) this;
        }

        public Criteria andCollegeNotEqualTo(String value) {
            addCriterion("COLLEGE <>", value, "college");
            return (Criteria) this;
        }

        public Criteria andCollegeGreaterThan(String value) {
            addCriterion("COLLEGE >", value, "college");
            return (Criteria) this;
        }

        public Criteria andCollegeGreaterThanOrEqualTo(String value) {
            addCriterion("COLLEGE >=", value, "college");
            return (Criteria) this;
        }

        public Criteria andCollegeLessThan(String value) {
            addCriterion("COLLEGE <", value, "college");
            return (Criteria) this;
        }

        public Criteria andCollegeLessThanOrEqualTo(String value) {
            addCriterion("COLLEGE <=", value, "college");
            return (Criteria) this;
        }

        public Criteria andCollegeLike(String value) {
            addCriterion("COLLEGE like", value, "college");
            return (Criteria) this;
        }

        public Criteria andCollegeNotLike(String value) {
            addCriterion("COLLEGE not like", value, "college");
            return (Criteria) this;
        }

        public Criteria andCollegeIn(List<String> values) {
            addCriterion("COLLEGE in", values, "college");
            return (Criteria) this;
        }

        public Criteria andCollegeNotIn(List<String> values) {
            addCriterion("COLLEGE not in", values, "college");
            return (Criteria) this;
        }

        public Criteria andCollegeBetween(String value1, String value2) {
            addCriterion("COLLEGE between", value1, value2, "college");
            return (Criteria) this;
        }

        public Criteria andCollegeNotBetween(String value1, String value2) {
            addCriterion("COLLEGE not between", value1, value2, "college");
            return (Criteria) this;
        }

        public Criteria andMajorIdIsNull() {
            addCriterion("MAJOR_ID is null");
            return (Criteria) this;
        }

        public Criteria andMajorIdIsNotNull() {
            addCriterion("MAJOR_ID is not null");
            return (Criteria) this;
        }

        public Criteria andMajorIdEqualTo(Integer value) {
            addCriterion("MAJOR_ID =", value, "majorId");
            return (Criteria) this;
        }

        public Criteria andMajorIdNotEqualTo(Integer value) {
            addCriterion("MAJOR_ID <>", value, "majorId");
            return (Criteria) this;
        }

        public Criteria andMajorIdGreaterThan(Integer value) {
            addCriterion("MAJOR_ID >", value, "majorId");
            return (Criteria) this;
        }

        public Criteria andMajorIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("MAJOR_ID >=", value, "majorId");
            return (Criteria) this;
        }

        public Criteria andMajorIdLessThan(Integer value) {
            addCriterion("MAJOR_ID <", value, "majorId");
            return (Criteria) this;
        }

        public Criteria andMajorIdLessThanOrEqualTo(Integer value) {
            addCriterion("MAJOR_ID <=", value, "majorId");
            return (Criteria) this;
        }

        public Criteria andMajorIdIn(List<Integer> values) {
            addCriterion("MAJOR_ID in", values, "majorId");
            return (Criteria) this;
        }

        public Criteria andMajorIdNotIn(List<Integer> values) {
            addCriterion("MAJOR_ID not in", values, "majorId");
            return (Criteria) this;
        }

        public Criteria andMajorIdBetween(Integer value1, Integer value2) {
            addCriterion("MAJOR_ID between", value1, value2, "majorId");
            return (Criteria) this;
        }

        public Criteria andMajorIdNotBetween(Integer value1, Integer value2) {
            addCriterion("MAJOR_ID not between", value1, value2, "majorId");
            return (Criteria) this;
        }

        public Criteria andMajorIsNull() {
            addCriterion("MAJOR is null");
            return (Criteria) this;
        }

        public Criteria andMajorIsNotNull() {
            addCriterion("MAJOR is not null");
            return (Criteria) this;
        }

        public Criteria andMajorEqualTo(String value) {
            addCriterion("MAJOR =", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotEqualTo(String value) {
            addCriterion("MAJOR <>", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorGreaterThan(String value) {
            addCriterion("MAJOR >", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorGreaterThanOrEqualTo(String value) {
            addCriterion("MAJOR >=", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorLessThan(String value) {
            addCriterion("MAJOR <", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorLessThanOrEqualTo(String value) {
            addCriterion("MAJOR <=", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorLike(String value) {
            addCriterion("MAJOR like", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotLike(String value) {
            addCriterion("MAJOR not like", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorIn(List<String> values) {
            addCriterion("MAJOR in", values, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotIn(List<String> values) {
            addCriterion("MAJOR not in", values, "major");
            return (Criteria) this;
        }

        public Criteria andMajorBetween(String value1, String value2) {
            addCriterion("MAJOR between", value1, value2, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotBetween(String value1, String value2) {
            addCriterion("MAJOR not between", value1, value2, "major");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateIsNull() {
            addCriterion("ADMISSION_DATE is null");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateIsNotNull() {
            addCriterion("ADMISSION_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateEqualTo(Date value) {
            addCriterion("ADMISSION_DATE =", value, "admissionDate");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateNotEqualTo(Date value) {
            addCriterion("ADMISSION_DATE <>", value, "admissionDate");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateGreaterThan(Date value) {
            addCriterion("ADMISSION_DATE >", value, "admissionDate");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateGreaterThanOrEqualTo(Date value) {
            addCriterion("ADMISSION_DATE >=", value, "admissionDate");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateLessThan(Date value) {
            addCriterion("ADMISSION_DATE <", value, "admissionDate");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateLessThanOrEqualTo(Date value) {
            addCriterion("ADMISSION_DATE <=", value, "admissionDate");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateIn(List<Date> values) {
            addCriterion("ADMISSION_DATE in", values, "admissionDate");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateNotIn(List<Date> values) {
            addCriterion("ADMISSION_DATE not in", values, "admissionDate");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateBetween(Date value1, Date value2) {
            addCriterion("ADMISSION_DATE between", value1, value2, "admissionDate");
            return (Criteria) this;
        }

        public Criteria andAdmissionDateNotBetween(Date value1, Date value2) {
            addCriterion("ADMISSION_DATE not between", value1, value2, "admissionDate");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdIsNull() {
            addCriterion("DIC_EDUCATION_ID is null");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdIsNotNull() {
            addCriterion("DIC_EDUCATION_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdEqualTo(Integer value) {
            addCriterion("DIC_EDUCATION_ID =", value, "dicEducationId");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdNotEqualTo(Integer value) {
            addCriterion("DIC_EDUCATION_ID <>", value, "dicEducationId");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdGreaterThan(Integer value) {
            addCriterion("DIC_EDUCATION_ID >", value, "dicEducationId");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DIC_EDUCATION_ID >=", value, "dicEducationId");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdLessThan(Integer value) {
            addCriterion("DIC_EDUCATION_ID <", value, "dicEducationId");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdLessThanOrEqualTo(Integer value) {
            addCriterion("DIC_EDUCATION_ID <=", value, "dicEducationId");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdIn(List<Integer> values) {
            addCriterion("DIC_EDUCATION_ID in", values, "dicEducationId");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdNotIn(List<Integer> values) {
            addCriterion("DIC_EDUCATION_ID not in", values, "dicEducationId");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdBetween(Integer value1, Integer value2) {
            addCriterion("DIC_EDUCATION_ID between", value1, value2, "dicEducationId");
            return (Criteria) this;
        }

        public Criteria andDicEducationIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DIC_EDUCATION_ID not between", value1, value2, "dicEducationId");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameIsNull() {
            addCriterion("DIC_EDUCATION_NAME is null");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameIsNotNull() {
            addCriterion("DIC_EDUCATION_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameEqualTo(String value) {
            addCriterion("DIC_EDUCATION_NAME =", value, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameNotEqualTo(String value) {
            addCriterion("DIC_EDUCATION_NAME <>", value, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameGreaterThan(String value) {
            addCriterion("DIC_EDUCATION_NAME >", value, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameGreaterThanOrEqualTo(String value) {
            addCriterion("DIC_EDUCATION_NAME >=", value, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameLessThan(String value) {
            addCriterion("DIC_EDUCATION_NAME <", value, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameLessThanOrEqualTo(String value) {
            addCriterion("DIC_EDUCATION_NAME <=", value, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameLike(String value) {
            addCriterion("DIC_EDUCATION_NAME like", value, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameNotLike(String value) {
            addCriterion("DIC_EDUCATION_NAME not like", value, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameIn(List<String> values) {
            addCriterion("DIC_EDUCATION_NAME in", values, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameNotIn(List<String> values) {
            addCriterion("DIC_EDUCATION_NAME not in", values, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameBetween(String value1, String value2) {
            addCriterion("DIC_EDUCATION_NAME between", value1, value2, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andDicEducationNameNotBetween(String value1, String value2) {
            addCriterion("DIC_EDUCATION_NAME not between", value1, value2, "dicEducationName");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationIsNull() {
            addCriterion("SELF_EVALUATION is null");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationIsNotNull() {
            addCriterion("SELF_EVALUATION is not null");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationEqualTo(String value) {
            addCriterion("SELF_EVALUATION =", value, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationNotEqualTo(String value) {
            addCriterion("SELF_EVALUATION <>", value, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationGreaterThan(String value) {
            addCriterion("SELF_EVALUATION >", value, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationGreaterThanOrEqualTo(String value) {
            addCriterion("SELF_EVALUATION >=", value, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationLessThan(String value) {
            addCriterion("SELF_EVALUATION <", value, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationLessThanOrEqualTo(String value) {
            addCriterion("SELF_EVALUATION <=", value, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationLike(String value) {
            addCriterion("SELF_EVALUATION like", value, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationNotLike(String value) {
            addCriterion("SELF_EVALUATION not like", value, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationIn(List<String> values) {
            addCriterion("SELF_EVALUATION in", values, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationNotIn(List<String> values) {
            addCriterion("SELF_EVALUATION not in", values, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationBetween(String value1, String value2) {
            addCriterion("SELF_EVALUATION between", value1, value2, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andSelfEvaluationNotBetween(String value1, String value2) {
            addCriterion("SELF_EVALUATION not between", value1, value2, "selfEvaluation");
            return (Criteria) this;
        }

        public Criteria andCardIsNull() {
            addCriterion("CARD is null");
            return (Criteria) this;
        }

        public Criteria andCardIsNotNull() {
            addCriterion("CARD is not null");
            return (Criteria) this;
        }

        public Criteria andCardEqualTo(String value) {
            addCriterion("CARD =", value, "card");
            return (Criteria) this;
        }

        public Criteria andCardNotEqualTo(String value) {
            addCriterion("CARD <>", value, "card");
            return (Criteria) this;
        }

        public Criteria andCardGreaterThan(String value) {
            addCriterion("CARD >", value, "card");
            return (Criteria) this;
        }

        public Criteria andCardGreaterThanOrEqualTo(String value) {
            addCriterion("CARD >=", value, "card");
            return (Criteria) this;
        }

        public Criteria andCardLessThan(String value) {
            addCriterion("CARD <", value, "card");
            return (Criteria) this;
        }

        public Criteria andCardLessThanOrEqualTo(String value) {
            addCriterion("CARD <=", value, "card");
            return (Criteria) this;
        }

        public Criteria andCardLike(String value) {
            addCriterion("CARD like", value, "card");
            return (Criteria) this;
        }

        public Criteria andCardNotLike(String value) {
            addCriterion("CARD not like", value, "card");
            return (Criteria) this;
        }

        public Criteria andCardIn(List<String> values) {
            addCriterion("CARD in", values, "card");
            return (Criteria) this;
        }

        public Criteria andCardNotIn(List<String> values) {
            addCriterion("CARD not in", values, "card");
            return (Criteria) this;
        }

        public Criteria andCardBetween(String value1, String value2) {
            addCriterion("CARD between", value1, value2, "card");
            return (Criteria) this;
        }

        public Criteria andCardNotBetween(String value1, String value2) {
            addCriterion("CARD not between", value1, value2, "card");
            return (Criteria) this;
        }

        public Criteria andIsInvitedIsNull() {
            addCriterion("IS_INVITED is null");
            return (Criteria) this;
        }

        public Criteria andIsInvitedIsNotNull() {
            addCriterion("IS_INVITED is not null");
            return (Criteria) this;
        }

        public Criteria andIsInvitedEqualTo(Integer value) {
            addCriterion("IS_INVITED =", value, "isInvited");
            return (Criteria) this;
        }

        public Criteria andIsInvitedNotEqualTo(Integer value) {
            addCriterion("IS_INVITED <>", value, "isInvited");
            return (Criteria) this;
        }

        public Criteria andIsInvitedGreaterThan(Integer value) {
            addCriterion("IS_INVITED >", value, "isInvited");
            return (Criteria) this;
        }

        public Criteria andIsInvitedGreaterThanOrEqualTo(Integer value) {
            addCriterion("IS_INVITED >=", value, "isInvited");
            return (Criteria) this;
        }

        public Criteria andIsInvitedLessThan(Integer value) {
            addCriterion("IS_INVITED <", value, "isInvited");
            return (Criteria) this;
        }

        public Criteria andIsInvitedLessThanOrEqualTo(Integer value) {
            addCriterion("IS_INVITED <=", value, "isInvited");
            return (Criteria) this;
        }

        public Criteria andIsInvitedIn(List<Integer> values) {
            addCriterion("IS_INVITED in", values, "isInvited");
            return (Criteria) this;
        }

        public Criteria andIsInvitedNotIn(List<Integer> values) {
            addCriterion("IS_INVITED not in", values, "isInvited");
            return (Criteria) this;
        }

        public Criteria andIsInvitedBetween(Integer value1, Integer value2) {
            addCriterion("IS_INVITED between", value1, value2, "isInvited");
            return (Criteria) this;
        }

        public Criteria andIsInvitedNotBetween(Integer value1, Integer value2) {
            addCriterion("IS_INVITED not between", value1, value2, "isInvited");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andDelIsNull() {
            addCriterion("DEL is null");
            return (Criteria) this;
        }

        public Criteria andDelIsNotNull() {
            addCriterion("DEL is not null");
            return (Criteria) this;
        }

        public Criteria andDelEqualTo(Integer value) {
            addCriterion("DEL =", value, "del");
            return (Criteria) this;
        }

        public Criteria andDelNotEqualTo(Integer value) {
            addCriterion("DEL <>", value, "del");
            return (Criteria) this;
        }

        public Criteria andDelGreaterThan(Integer value) {
            addCriterion("DEL >", value, "del");
            return (Criteria) this;
        }

        public Criteria andDelGreaterThanOrEqualTo(Integer value) {
            addCriterion("DEL >=", value, "del");
            return (Criteria) this;
        }

        public Criteria andDelLessThan(Integer value) {
            addCriterion("DEL <", value, "del");
            return (Criteria) this;
        }

        public Criteria andDelLessThanOrEqualTo(Integer value) {
            addCriterion("DEL <=", value, "del");
            return (Criteria) this;
        }

        public Criteria andDelIn(List<Integer> values) {
            addCriterion("DEL in", values, "del");
            return (Criteria) this;
        }

        public Criteria andDelNotIn(List<Integer> values) {
            addCriterion("DEL not in", values, "del");
            return (Criteria) this;
        }

        public Criteria andDelBetween(Integer value1, Integer value2) {
            addCriterion("DEL between", value1, value2, "del");
            return (Criteria) this;
        }

        public Criteria andDelNotBetween(Integer value1, Integer value2) {
            addCriterion("DEL not between", value1, value2, "del");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}